package com.cc.visitor.dao;

import com.cc.visitor.entity.Employee;
import com.mybatisflex.core.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author chanchaw
 * @create 2024-09-26 16:10
 */
@Repository
public interface EmployeeMapper extends BaseMapper<Employee> {
    @Select("call usp_getEmployee8DepartmentSid(#{departmentSid})")
    List<Employee> getEmployee8DepartmentSid(@Param("departmentSid") String departmentSid);
    @Select("call usp_getEmployee8DepartmentSidAndName(#{departmentSid},#{name})")
    List<Employee> getEmployee8DepartmentAndName(@Param("departmentSid") String departmentSid,@Param("name")String name);
    @Select("select * from employee where sname=#{sname}")
    List<Employee> get8sname(@Param("sname") String sname);
}
